﻿// MIT License
//
// Copyright (c) 2021-present zuohuaijun, Daming Co.,Ltd and Contributors
//
// 电话/微信：18020030720 QQ群1：87333204 QQ群2：252381476

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Admin.Net.InformationPlatform.Entity.Product;
/// <summary>
/// 提交订单信息类
/// </summary>
[SugarTable("SJADMIN.ORDER_PRODUCT")]
public class OrderProduct
{


    /// <summary>
    /// pid
    /// </summary>
    [SugarColumn(ColumnName = "PID", IsPrimaryKey = true)]
    public int PID { get; set; }  


    /// <summary>
    /// 订单编号
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_ID")]
    public string ORDERID { get; set; }  =string.Empty;

    /// <summary>
    /// 客户编号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_ID")]
    public string CUSTOMERID { get; set; }  =string.Empty;

    /// <summary>
    /// 客户简称
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_NAME")]
    public string CUSTOMERNAME { get; set; } = string.Empty;

    /// <summary>
    /// 客户料号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_MID")]
    public string CUSTOMERMID { get; set; }  =string.Empty;

    /// <summary>
    /// 客户料号品名
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_MNAME")]
    public string CUSTOMERMNAME { get; set; }  =string.Empty;

    /// <summary>
    /// 客户料号规格
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_SPECS")]
    public string MATERIALSPECS { get; set; }  =string.Empty;

    /// <summary>
    /// 生久料号
    /// </summary>
    [SugarColumn(ColumnName = "SJ_MID")]
    public string SJMID { get; set; }  =string.Empty;


    /// <summary>
    /// bom特性
    /// </summary>
    [SugarColumn(ColumnName = "BOM_FEATURE")]
    public string BOMFEATURE { get; set; }  =string.Empty;

    /// <summary>
    /// 品名
    /// </summary>
    [SugarColumn(ColumnName = "MNAME")]
    public string MNAME { get; set; }  =string.Empty;

    /// <summary>
    /// 规格
    /// </summary>
    [SugarColumn(ColumnName = "SPECS")]
    public string SPECS { get; set; }  =string.Empty;

    /// <summary>
    /// 单位
    /// </summary>
    [SugarColumn(ColumnName = "UNIT_LENGTH")]
    public string UNITLENGTH { get; set; }  =string.Empty;

    /// <summary>
    /// 单位名称
    /// </summary>
    [SugarColumn(ColumnName = "Unit_Name")]
    public string UNITNAME { get; set; }  =string.Empty;

    /// <summary>
    /// 连杆长度
    /// </summary>
    [SugarColumn(ColumnName = "COUPLER_LENGTH")]
    public string COUPLERLENGTH { get; set; }  =string.Empty;

    /// <summary>
    /// 订购量
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_QUANTITY")]
    public int PURCHASEQUANTITY { get; set; }  

    /// <summary>
    /// 直发客户
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_INFORMATION")]
    public string CUSTOMERINFORMATION { get; set; }  =string.Empty;

    /// <summary>
    /// 预定交货日期
    /// </summary>
    [SugarColumn(ColumnName = "PRESET_DATE")]
    public DateTime? PRESETDATE { get; set; } 

    /// <summary>
    /// 行状态
    /// </summary>
    [SugarColumn(ColumnName = "ROW_STATUS")]
    public string ROWSTATUS { get; set; }  =string.Empty;

    /// <summary>
    /// 税种
    /// </summary>
    [SugarColumn(ColumnName = "TAX_MESSAGE")]
    public string TAXMESSAGE { get; set; }  =string.Empty;

    /// <summary>
    /// 说明
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_DESCRIPTION")]
    public string ORDERDESCRIPTION { get; set; }  =string.Empty;

    /// <summary>
    /// 税率
    /// </summary>
    [SugarColumn(ColumnName = "TAX_RATES")]
    public int TAXRATES { get; set; }  

    /// <summary>
    /// 税前金额
    /// </summary>
    [SugarColumn(ColumnName = "PRE_TAX_AMOUNT")]
    public double PRETAXAMOUNT { get; set; }  

    /// <summary>
    /// 含税金额 
    /// </summary>
    [SugarColumn(ColumnName = "HAVE_TAX_AMOUNT")]
    public double HAVETAXAMOUNT { get; set; }  

    /// <summary>
    /// 税额
    /// </summary>
    [SugarColumn(ColumnName = "TAX_COUNT")]
    public double TAXCOUNT { get; set; } 

    /// <summary>
    /// 库存
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY")]
    public int INVENTORY { get; set; }  

    /// <summary>
    /// 订购金额
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_AMOUNT")]
    public double ORDERAMOUNT { get; set; } 

    /// <summary>
    /// 备注
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_REMARK")]
    public string ORDERREMARK { get; set; }  =string.Empty;

    /// <summary>
    /// 长备注
    /// </summary>
    [SugarColumn(ColumnName = "LONG_REMARK")]
    public string LONGREMARK { get; set; }  =string.Empty;
    /// <summary>
    /// 下单日期
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_DATE")]
    public DateTime? ORDERDATE { get; set; }

    /// <summary>
    /// 订单状态
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_STATUS")]
    public int ORDERSTATUS { get; set; }


    /// <summary>
    /// 部分交货
    /// </summary>
    [SugarColumn(ColumnName = "PARTIAL_DELIVERY")]
    public int ISPARTIALDELIVERY { get; set; }

    /// <summary>
    /// 理由码
    /// </summary>
    [SugarColumn(ColumnName = "REASON_CODE")]
    public string REASONCODE { get; set; } = string.Empty;

    /// <summary>
    /// 理由码说明
    /// </summary>
    [SugarColumn(ColumnName = "REASON_EXPLAIN")]
    public string REASONCODEEXPLAIN { get; set; } = string.Empty;

    /// <summary>
    /// 结束码
    /// </summary>
    [SugarColumn(ColumnName = "FINISHE_CODE")]
    public string FINISHECODE { get; set; } = string.Empty;

    /// <summary>
    /// 结束码说明
    /// </summary>
    [SugarColumn(ColumnName = "FINISHE_EXPLAIN")]
    public string FINISHECODEEXPLAIN { get; set; } = string.Empty;


    /// <summary>
    /// 收款据点
    /// </summary>
    [SugarColumn(ColumnName = "INCHARGE_AREA")]
    public string INCHARGEAREA { get; set; } = string.Empty;

    /// <summary>
    /// 收款据点名称
    /// </summary>
    [SugarColumn(ColumnName = "INCHARGE_AREANAME")]
    public string INCHARGEAREANAME { get; set; } = string.Empty;

    /// <summary>
    /// 出货据点
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_AREA")]
    public string DELIVERYAREA { get; set; } = string.Empty;

    /// <summary>
    /// 出货据点名称
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_AREANAME")]
    public string DELIVERYAREANAME { get; set; } = string.Empty;


    /// <summary>
    /// 紧急度
    /// </summary>
    [SugarColumn(ColumnName = "URGENCY")]
    public string URGENCY { get; set; } = string.Empty;

    /// <summary>
    /// t100单号
    /// </summary>
    [SugarColumn(ColumnName = "T100ID")]
    public string T100ID { get; set; } = string.Empty;
}
